{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Linea","formato para imprimir","Conceptos","Ejemplos"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Linea","index":0,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"LINEA DE CAPTURA PARA ALUMNOS DE NUEVO INGRESO"]
["N_control"]
["Concepto",null,{"$f":"IFERROR(VLOOKUP(B22,Conceptos!B3:D4,3,FALSE),\"\")","v":""}]
["Monto",{"$f":"IFERROR(VLOOKUP(C22,Conceptos!$A$3:$C$1048576,3,FALSE),\"\")","v":""}]
["Apellido Paterno"]
["Apelido Materno"]
["Nombre(s)"]
["Semestre/Nivel"]
["Carrera",null,{"$f":"IFERROR(VLOOKUP(B28,Conceptos!F10:G16,2,FALSE),\" \")","v":" "}]

{"sheet":"formato para imprimir","index":1,"n_rows":1414,"n_cols":48,"rows_kept":1414,"cut":false,"hidden":false,"merged":[[9,32,9,38],[11,1,11,4],[13,1,13,4],[9,10,9,16],[2,2,3,44],[11,5,11,45],[13,35,13,38],[13,5,13,33],[9,1,9,9],[9,39,9,47],[5,1,6,5],[13,39,13,47],[19,7,21,37],[17,9,17,20],[17,1,17,8],[15,1,15,4],[15,5,15,32]]}
[]
[]
[null,null,"INSTITUTO TECNOLÓGICO DE GUSTAVO A. MADERO II"]
[]
[]
[null,"Linea de Captura"]
[]
[null,"B:",{"$f":"IF(Linea!C20=\"\",\"\",Linea!C20)","v":""},{"$f":"IF(Linea!D20=\"\",\"\",Linea!D20)","v":""},{"$f":"IF(Linea!E20=\"\",\"\",Linea!E20)","v":""},{"$f":"IF(Linea!F20=\"\",\"\",Linea!F20)","v":""},{"$f":"IF(Linea!G20=\"\",\"\",Linea!G20)","v":""},{"$f":"IF(Linea!H20=\"\",\"\",Linea!H20)","v":""},{"$f":"IF(Linea!I20=\"\",\"\",Linea!I20)","v":""},{"$f":"IF(Linea!J20=\"\",\"\",Linea!J20)","v":""},{"$f":"IF(Linea!K20=\"\",\"\",Linea!K20)","v":""},{"$f":"IF(Linea!L20=\"\",\"\",Linea!L20)","v":""},{"$f":"IF(Linea!M20=\"\",\"\",Linea!M20)","v":""},{"$f":"IF(Linea!N20=\"\",\"\",Linea!N20)","v":""},{"$f":"IF(Linea!O20=\"\",\"\",Linea!O20)","v":""},{"$f":"IF(Linea!P20=\"\",\"\",Linea!P20)","v":""},{"$f":"IF(Linea!Q20=\"\",\"\",Linea!Q20)","v":""},{"$f":"IF(Linea!R20=\"\",\"\",Linea!R20)","v":""},{"$f":"IF(Linea!S20=\"\",\"\",Linea!S20)","v":""},{"$f":"IF(Linea!T20=\"\",\"\",Linea!T20)","v":""},{"$f":"IF(Linea!U20=\"\",\"\",Linea!U20)","v":""},{"$f":"IF(Linea!V20=\"\",\"\",Linea!V20)","v":""},{"$f":"IF(Linea!W20=\"\",\"\",Linea!W20)","v":""},{"$f":"IF(Linea!X20=\"\",\"\",Linea!X20)","v":""},{"$f":"IF(Linea!Y20=\"\",\"\",Linea!Y20)","v":""},{"$f":"IF(Linea!Z20=\"\",\"\",Linea!Z20)","v":""},{"$f":"IF(Linea!AA20=\"\",\"\",Linea!AA20)","v":""},{"$f":"IF(Linea!AB20=\"\",\"\",Linea!AB20)","v":""},{"$f":"IF(Linea!AC20=\"\",\"\",Linea!AC20)","v":""},{"$f":"IF(Linea!AD20=\"\",\"\",Linea!AD20)","v":""},{"$f":"IF(Linea!AE20=\"\",\"\",Linea!AE20)","v":""},{"$f":"IF(Linea!AF20=\"\",\"\",Linea!AF20)","v":""},{"$f":"IF(Linea!AG20=\"\",\"\",Linea!AG20)","v":""},{"$f":"IF(Linea!AH20=\"\",\"\",Linea!AH20)","v":""},{"$f":"IF(Linea!AI20=\"\",\"\",Linea!AI20)","v":""},{"$f":"IF(Linea!AJ20=\"\",\"\",Linea!AJ20)","v":""},{"$f":"IF(Linea!AK20=\"\",\"\",Linea!AK20)","v":""},{"$f":"IF(Linea!AL20=\"\",\"\",Linea!AL20)","v":""},{"$f":"IF(Linea!AM20=\"\",\"\",Linea!AM20)","v":""},{"$f":"IF(Linea!AN20=\"\",\"\",Linea!AN20)","v":""},{"$f":"IF(Linea!AO20=\"\",\"\",Linea!AO20)","v":""},{"$f":"IF(Linea!AP20=\"\",\"\",Linea!AP20)","v":""},{"$f":"IF(Linea!AQ20=\"\",\"\",Linea!AQ20)","v":""},{"$f":"IF(Linea!AR20=\"\",\"\",Linea!AR20)","v":""},{"$f":"IF(Linea!AS20=\"\",\"\",Linea!AS20)","v":""},{"$f":"IF(Linea!AT20=\"\",\"\",Linea!AT20)","v":""},{"$f":"IF(Linea!AU20=\"\",\"\",Linea!AU20)","v":""},{"$f":"IF(Linea!AV20=\"\",\"\",Linea!AV20)","v":""}]
[]
[null,"Nùmero de Control:",null,null,null,null,null,null,null,null,{"$f":"UPPER(Linea!$B$21)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semestre",null,null,null,null,null,null,{"$f":"IF(Linea!B27=\"\",\"\",Linea!B27)","v":""}]
[]
[null,"Nombre completo:",null,null,null,{"$f":"UPPER(CONCATENATE(Linea!$B$26,\" \",Linea!$B$24,\" \",Linea!$B$25))","v":"  "}]
[]
[null,"Concepto:",null,null,null,{"$f":"UPPER(Linea!$B$22)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monto:",null,null,null,{"$f":"IF(Linea!C24=\"\",\"\",Linea!C24)","v":""}]
[]
[null,"Carrera:",null,null,null,{"$f":"UPPER(Linea!$B$28)","v":""}]
[]
[null,"Fecha limite de pago:",null,null,null,null,null,null,null,{"$f":"IF(Linea!C25=\"\",\"\",Linea!C25)","v":""}]
[]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"PERIODO \",IF(AND(MONTH(NOW())>=1,MONTH(NOW())<=8),CONCATENATE(\"AGOSTO - DICIEMBRE \",YEAR(NOW())),CONCATENATE(\"ENERO - JUNIO \",YEAR(NOW())+1)))","v":"PERIODO AGOSTO - DICIEMBRE 2024"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50]

{"sheet":"Conceptos","index":2,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[]
["CLAVE","CONCEPTO","MONTO","Departamento","00","General (Todos)",null,null,null,"SEMESTRE"]
["0000000000502","Inscripción Nuevo Ingreso",2800,{"$f":"A3","v":"0000000000502"},null,null,null,null,null,"00"]
["0000000000503","Pago de Ficha de Examen de Nuevo Ingreso",800,"0000000000503","01","Servicios Escolares",null,null,null,"01"]
[null,null,null,null,"02","División de Estudios Profesionales",null,null,null,"02"]
[null,null,null,null,"03","Biblioteca",null,null,null,"03"]
[null,null,null,null,"04","Vinculación",null,null,null,"04"]
[null,null,null,null,"05","Desarrollo Académico",null,null,null,"05"]
[null,null,null,null,"06","Planeación y Vinculación",null,null,null,"06"]
[null,null,null,null,null,"ING. ADMINISTRACIÓN","01",null,null,"07"]
[null,null,null,null,null,"ARQUITECTURA","03",null,null,"08"]
[null,null,null,null,null,"ING. INDUSTRIAL","02",null,null,"09"]
[null,null,null,null,null,"INGLES INTERNO","04",null,null,"10"]
[null,null,null,null,null,"INGLES EXTERNO","05",null,null,"11"]
[null,null,null,null,null,"ADMINISTRATIVO","06",null,null,"12"]
[null,null,null,null,null,"ITIC´S","07",null,null,"Más de 12 semestres"]
[null,null,null,null,null,null,null,null,null,"Administativo"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"LEN(A4)","v":13}]
[null,null,null,null,null,null,null,{"$f":"LEN(A3)","v":13}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"LEN(A4)","v":13}]

{"sheet":"Ejemplos","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}